Using SQLite syntax with filtering
Qlik Replicate supports the following SQLite operators when creating Record Selection Condition filters.
You must put the ($) in front of each input as shown below.
| Operator | Description |
|---|---|
|
< |
Is less than. $SALARY<100000 |
|
<= |
Is less than or equal to $SALARY<=100000 |
|
> |
Is greater than $SALARY>100000 |
|
>= |
Is more than or equal to $SALARY>=100000 |
|
= |
Is equal to $SALARY=100000 |
|
!= or <> |
Is not equal to $SALARY!=100000 |
|
IS |
Is the same as $HIRE_DATE IS 2014-09-29 IS functions the same as = unless one or both of the operands are NULL. In this case, if both operands are NULL, then the IS operator evaluates to 1 (true). If one operand is NULL and the other is not, then the IS operator evaluates to 0 (false). |
|
IS NOT |
Is not the same as $HIRE_DATE IS NOT 2014-09-29 IS NOT functions the same as != unless one or both of the operands are NULL. In this case, if both operands are NULL, the IS NOT operator evaluates to 0 (false). If one operand is NULL and the other is not, then the IS NOT operator evaluates to 1 (true). |
|
AND |
Both operands are true. $MANAGER_ID AND EMPLOYEE ID >100 |
|
OR |
Either operand is true. $MANAGER_ID OR EMPLOYEE ID >100 |
For more information on how to use the SQLite syntax, see the SQLite documentation.